package com.ruoyi.web.controller.shop.mapper;

import com.ruoyi.common.core.dao.BaseMapper;
import com.ruoyi.common.entity.DO.member.MemberVipBenefitExtDO;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface IBackShopMemberVipBenefitExtMapper extends BaseMapper<MemberVipBenefitExtDO> {

    @Select("SELECT id,benefit_discount_rate benefitDiscountRate FROM member_vip_benefit_ext where member_id=#{memberId} and product_id=#{productId} LIMIT 1")
    MemberVipBenefitExtDO selectOneForAU(@Param("memberId") Long memberId, @Param("productId") Long productId);
}
